package com.bm.server.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bm.common.dto.BloodBlockDto;
import com.bm.server.entity.BloodBlock;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Hey man，take your time！
 *
 * @Author: 李松洋
 * @Description:代码永不报错，工资永在上涨！！！
 * @Date: Create in 16:38 2022/7/22
 *查询血染钟楼的房间
 */
public interface BloodBlockDao extends BaseMapper<BloodBlock> {
    @Select("SELECT u.nickname,b.type,b.flag,b.num FROM t_bloodblock AS b\n" +
            "INNER JOIN t_userinfo AS u\n" +
            "ON b.uid=u.uid")
    List<BloodBlockDto> bloodBlock();
}
